package com.ttj.domain.oracle.gen;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class ConfigCustomerCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer mysqlOffset;

    protected Integer mysqlLength;

    public ConfigCustomerCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlOffset(Integer mysqlOffset) {
        this.mysqlOffset=mysqlOffset;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlOffset() {
        return mysqlOffset;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlLength(Integer mysqlLength) {
        this.mysqlLength=mysqlLength;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlLength() {
        return mysqlLength;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andNameIsNull() {
            addCriterion("NAME is null");
            return (Criteria) this;
        }

        public Criteria andNameIsNotNull() {
            addCriterion("NAME is not null");
            return (Criteria) this;
        }

        public Criteria andNameEqualTo(String value) {
            addCriterion("NAME =", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotEqualTo(String value) {
            addCriterion("NAME <>", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThan(String value) {
            addCriterion("NAME >", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameGreaterThanOrEqualTo(String value) {
            addCriterion("NAME >=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThan(String value) {
            addCriterion("NAME <", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLessThanOrEqualTo(String value) {
            addCriterion("NAME <=", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameLike(String value) {
            addCriterion("NAME like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotLike(String value) {
            addCriterion("NAME not like", value, "name");
            return (Criteria) this;
        }

        public Criteria andNameIn(List<String> values) {
            addCriterion("NAME in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotIn(List<String> values) {
            addCriterion("NAME not in", values, "name");
            return (Criteria) this;
        }

        public Criteria andNameBetween(String value1, String value2) {
            addCriterion("NAME between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andNameNotBetween(String value1, String value2) {
            addCriterion("NAME not between", value1, value2, "name");
            return (Criteria) this;
        }

        public Criteria andTypeIsNull() {
            addCriterion("TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTypeIsNotNull() {
            addCriterion("TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTypeEqualTo(Integer value) {
            addCriterion("TYPE =", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotEqualTo(Integer value) {
            addCriterion("TYPE <>", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThan(Integer value) {
            addCriterion("TYPE >", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("TYPE >=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThan(Integer value) {
            addCriterion("TYPE <", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeLessThanOrEqualTo(Integer value) {
            addCriterion("TYPE <=", value, "type");
            return (Criteria) this;
        }

        public Criteria andTypeIn(List<Integer> values) {
            addCriterion("TYPE in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotIn(List<Integer> values) {
            addCriterion("TYPE not in", values, "type");
            return (Criteria) this;
        }

        public Criteria andTypeBetween(Integer value1, Integer value2) {
            addCriterion("TYPE between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("TYPE not between", value1, value2, "type");
            return (Criteria) this;
        }

        public Criteria andCLevelIsNull() {
            addCriterion("C_LEVEL is null");
            return (Criteria) this;
        }

        public Criteria andCLevelIsNotNull() {
            addCriterion("C_LEVEL is not null");
            return (Criteria) this;
        }

        public Criteria andCLevelEqualTo(Integer value) {
            addCriterion("C_LEVEL =", value, "cLevel");
            return (Criteria) this;
        }

        public Criteria andCLevelNotEqualTo(Integer value) {
            addCriterion("C_LEVEL <>", value, "cLevel");
            return (Criteria) this;
        }

        public Criteria andCLevelGreaterThan(Integer value) {
            addCriterion("C_LEVEL >", value, "cLevel");
            return (Criteria) this;
        }

        public Criteria andCLevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("C_LEVEL >=", value, "cLevel");
            return (Criteria) this;
        }

        public Criteria andCLevelLessThan(Integer value) {
            addCriterion("C_LEVEL <", value, "cLevel");
            return (Criteria) this;
        }

        public Criteria andCLevelLessThanOrEqualTo(Integer value) {
            addCriterion("C_LEVEL <=", value, "cLevel");
            return (Criteria) this;
        }

        public Criteria andCLevelIn(List<Integer> values) {
            addCriterion("C_LEVEL in", values, "cLevel");
            return (Criteria) this;
        }

        public Criteria andCLevelNotIn(List<Integer> values) {
            addCriterion("C_LEVEL not in", values, "cLevel");
            return (Criteria) this;
        }

        public Criteria andCLevelBetween(Integer value1, Integer value2) {
            addCriterion("C_LEVEL between", value1, value2, "cLevel");
            return (Criteria) this;
        }

        public Criteria andCLevelNotBetween(Integer value1, Integer value2) {
            addCriterion("C_LEVEL not between", value1, value2, "cLevel");
            return (Criteria) this;
        }

        public Criteria andAttributeIsNull() {
            addCriterion("ATTRIBUTE is null");
            return (Criteria) this;
        }

        public Criteria andAttributeIsNotNull() {
            addCriterion("ATTRIBUTE is not null");
            return (Criteria) this;
        }

        public Criteria andAttributeEqualTo(String value) {
            addCriterion("ATTRIBUTE =", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeNotEqualTo(String value) {
            addCriterion("ATTRIBUTE <>", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeGreaterThan(String value) {
            addCriterion("ATTRIBUTE >", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeGreaterThanOrEqualTo(String value) {
            addCriterion("ATTRIBUTE >=", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeLessThan(String value) {
            addCriterion("ATTRIBUTE <", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeLessThanOrEqualTo(String value) {
            addCriterion("ATTRIBUTE <=", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeLike(String value) {
            addCriterion("ATTRIBUTE like", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeNotLike(String value) {
            addCriterion("ATTRIBUTE not like", value, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeIn(List<String> values) {
            addCriterion("ATTRIBUTE in", values, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeNotIn(List<String> values) {
            addCriterion("ATTRIBUTE not in", values, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeBetween(String value1, String value2) {
            addCriterion("ATTRIBUTE between", value1, value2, "attribute");
            return (Criteria) this;
        }

        public Criteria andAttributeNotBetween(String value1, String value2) {
            addCriterion("ATTRIBUTE not between", value1, value2, "attribute");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("STATUS is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("STATUS =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("STATUS <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("STATUS >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("STATUS >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("STATUS <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("STATUS <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("STATUS in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("STATUS not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("STATUS between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("STATUS not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andAddrIsNull() {
            addCriterion("ADDR is null");
            return (Criteria) this;
        }

        public Criteria andAddrIsNotNull() {
            addCriterion("ADDR is not null");
            return (Criteria) this;
        }

        public Criteria andAddrEqualTo(String value) {
            addCriterion("ADDR =", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotEqualTo(String value) {
            addCriterion("ADDR <>", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrGreaterThan(String value) {
            addCriterion("ADDR >", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrGreaterThanOrEqualTo(String value) {
            addCriterion("ADDR >=", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrLessThan(String value) {
            addCriterion("ADDR <", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrLessThanOrEqualTo(String value) {
            addCriterion("ADDR <=", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrLike(String value) {
            addCriterion("ADDR like", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotLike(String value) {
            addCriterion("ADDR not like", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrIn(List<String> values) {
            addCriterion("ADDR in", values, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotIn(List<String> values) {
            addCriterion("ADDR not in", values, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrBetween(String value1, String value2) {
            addCriterion("ADDR between", value1, value2, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotBetween(String value1, String value2) {
            addCriterion("ADDR not between", value1, value2, "addr");
            return (Criteria) this;
        }

        public Criteria andAccountNameIsNull() {
            addCriterion("ACCOUNT_NAME is null");
            return (Criteria) this;
        }

        public Criteria andAccountNameIsNotNull() {
            addCriterion("ACCOUNT_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andAccountNameEqualTo(String value) {
            addCriterion("ACCOUNT_NAME =", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameNotEqualTo(String value) {
            addCriterion("ACCOUNT_NAME <>", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameGreaterThan(String value) {
            addCriterion("ACCOUNT_NAME >", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameGreaterThanOrEqualTo(String value) {
            addCriterion("ACCOUNT_NAME >=", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameLessThan(String value) {
            addCriterion("ACCOUNT_NAME <", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameLessThanOrEqualTo(String value) {
            addCriterion("ACCOUNT_NAME <=", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameLike(String value) {
            addCriterion("ACCOUNT_NAME like", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameNotLike(String value) {
            addCriterion("ACCOUNT_NAME not like", value, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameIn(List<String> values) {
            addCriterion("ACCOUNT_NAME in", values, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameNotIn(List<String> values) {
            addCriterion("ACCOUNT_NAME not in", values, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameBetween(String value1, String value2) {
            addCriterion("ACCOUNT_NAME between", value1, value2, "accountName");
            return (Criteria) this;
        }

        public Criteria andAccountNameNotBetween(String value1, String value2) {
            addCriterion("ACCOUNT_NAME not between", value1, value2, "accountName");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNull() {
            addCriterion("BANK_NAME is null");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNotNull() {
            addCriterion("BANK_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andBankNameEqualTo(String value) {
            addCriterion("BANK_NAME =", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotEqualTo(String value) {
            addCriterion("BANK_NAME <>", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThan(String value) {
            addCriterion("BANK_NAME >", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_NAME >=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThan(String value) {
            addCriterion("BANK_NAME <", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThanOrEqualTo(String value) {
            addCriterion("BANK_NAME <=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLike(String value) {
            addCriterion("BANK_NAME like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotLike(String value) {
            addCriterion("BANK_NAME not like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameIn(List<String> values) {
            addCriterion("BANK_NAME in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotIn(List<String> values) {
            addCriterion("BANK_NAME not in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameBetween(String value1, String value2) {
            addCriterion("BANK_NAME between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotBetween(String value1, String value2) {
            addCriterion("BANK_NAME not between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNumIsNull() {
            addCriterion("BANK_NUM is null");
            return (Criteria) this;
        }

        public Criteria andBankNumIsNotNull() {
            addCriterion("BANK_NUM is not null");
            return (Criteria) this;
        }

        public Criteria andBankNumEqualTo(String value) {
            addCriterion("BANK_NUM =", value, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumNotEqualTo(String value) {
            addCriterion("BANK_NUM <>", value, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumGreaterThan(String value) {
            addCriterion("BANK_NUM >", value, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumGreaterThanOrEqualTo(String value) {
            addCriterion("BANK_NUM >=", value, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumLessThan(String value) {
            addCriterion("BANK_NUM <", value, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumLessThanOrEqualTo(String value) {
            addCriterion("BANK_NUM <=", value, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumLike(String value) {
            addCriterion("BANK_NUM like", value, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumNotLike(String value) {
            addCriterion("BANK_NUM not like", value, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumIn(List<String> values) {
            addCriterion("BANK_NUM in", values, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumNotIn(List<String> values) {
            addCriterion("BANK_NUM not in", values, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumBetween(String value1, String value2) {
            addCriterion("BANK_NUM between", value1, value2, "bankNum");
            return (Criteria) this;
        }

        public Criteria andBankNumNotBetween(String value1, String value2) {
            addCriterion("BANK_NUM not between", value1, value2, "bankNum");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameIsNull() {
            addCriterion("INVOICE_NAME is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameIsNotNull() {
            addCriterion("INVOICE_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameEqualTo(String value) {
            addCriterion("INVOICE_NAME =", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameNotEqualTo(String value) {
            addCriterion("INVOICE_NAME <>", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameGreaterThan(String value) {
            addCriterion("INVOICE_NAME >", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameGreaterThanOrEqualTo(String value) {
            addCriterion("INVOICE_NAME >=", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameLessThan(String value) {
            addCriterion("INVOICE_NAME <", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameLessThanOrEqualTo(String value) {
            addCriterion("INVOICE_NAME <=", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameLike(String value) {
            addCriterion("INVOICE_NAME like", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameNotLike(String value) {
            addCriterion("INVOICE_NAME not like", value, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameIn(List<String> values) {
            addCriterion("INVOICE_NAME in", values, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameNotIn(List<String> values) {
            addCriterion("INVOICE_NAME not in", values, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameBetween(String value1, String value2) {
            addCriterion("INVOICE_NAME between", value1, value2, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceNameNotBetween(String value1, String value2) {
            addCriterion("INVOICE_NAME not between", value1, value2, "invoiceName");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNull() {
            addCriterion("INVOICE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIsNotNull() {
            addCriterion("INVOICE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeEqualTo(Integer value) {
            addCriterion("INVOICE_TYPE =", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotEqualTo(Integer value) {
            addCriterion("INVOICE_TYPE <>", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeGreaterThan(Integer value) {
            addCriterion("INVOICE_TYPE >", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("INVOICE_TYPE >=", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeLessThan(Integer value) {
            addCriterion("INVOICE_TYPE <", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeLessThanOrEqualTo(Integer value) {
            addCriterion("INVOICE_TYPE <=", value, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeIn(List<Integer> values) {
            addCriterion("INVOICE_TYPE in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotIn(List<Integer> values) {
            addCriterion("INVOICE_TYPE not in", values, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeBetween(Integer value1, Integer value2) {
            addCriterion("INVOICE_TYPE between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andInvoiceTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("INVOICE_TYPE not between", value1, value2, "invoiceType");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("REMARK is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("REMARK =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("REMARK <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("REMARK >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("REMARK >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("REMARK <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("REMARK <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("REMARK like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("REMARK not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("REMARK in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("REMARK not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("REMARK between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("REMARK not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andIndateIsNull() {
            addCriterion("INDATE is null");
            return (Criteria) this;
        }

        public Criteria andIndateIsNotNull() {
            addCriterion("INDATE is not null");
            return (Criteria) this;
        }

        public Criteria andIndateEqualTo(Date value) {
            addCriterion("INDATE =", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateNotEqualTo(Date value) {
            addCriterion("INDATE <>", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateGreaterThan(Date value) {
            addCriterion("INDATE >", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateGreaterThanOrEqualTo(Date value) {
            addCriterion("INDATE >=", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateLessThan(Date value) {
            addCriterion("INDATE <", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateLessThanOrEqualTo(Date value) {
            addCriterion("INDATE <=", value, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateIn(List<Date> values) {
            addCriterion("INDATE in", values, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateNotIn(List<Date> values) {
            addCriterion("INDATE not in", values, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateBetween(Date value1, Date value2) {
            addCriterion("INDATE between", value1, value2, "indate");
            return (Criteria) this;
        }

        public Criteria andIndateNotBetween(Date value1, Date value2) {
            addCriterion("INDATE not between", value1, value2, "indate");
            return (Criteria) this;
        }

        public Criteria andModifTimeIsNull() {
            addCriterion("MODIF_TIME is null");
            return (Criteria) this;
        }

        public Criteria andModifTimeIsNotNull() {
            addCriterion("MODIF_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andModifTimeEqualTo(Date value) {
            addCriterion("MODIF_TIME =", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotEqualTo(Date value) {
            addCriterion("MODIF_TIME <>", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeGreaterThan(Date value) {
            addCriterion("MODIF_TIME >", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("MODIF_TIME >=", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeLessThan(Date value) {
            addCriterion("MODIF_TIME <", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeLessThanOrEqualTo(Date value) {
            addCriterion("MODIF_TIME <=", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeIn(List<Date> values) {
            addCriterion("MODIF_TIME in", values, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotIn(List<Date> values) {
            addCriterion("MODIF_TIME not in", values, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeBetween(Date value1, Date value2) {
            addCriterion("MODIF_TIME between", value1, value2, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotBetween(Date value1, Date value2) {
            addCriterion("MODIF_TIME not between", value1, value2, "modifTime");
            return (Criteria) this;
        }

        public Criteria andInauthorIsNull() {
            addCriterion("INAUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andInauthorIsNotNull() {
            addCriterion("INAUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andInauthorEqualTo(String value) {
            addCriterion("INAUTHOR =", value, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorNotEqualTo(String value) {
            addCriterion("INAUTHOR <>", value, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorGreaterThan(String value) {
            addCriterion("INAUTHOR >", value, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorGreaterThanOrEqualTo(String value) {
            addCriterion("INAUTHOR >=", value, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorLessThan(String value) {
            addCriterion("INAUTHOR <", value, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorLessThanOrEqualTo(String value) {
            addCriterion("INAUTHOR <=", value, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorLike(String value) {
            addCriterion("INAUTHOR like", value, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorNotLike(String value) {
            addCriterion("INAUTHOR not like", value, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorIn(List<String> values) {
            addCriterion("INAUTHOR in", values, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorNotIn(List<String> values) {
            addCriterion("INAUTHOR not in", values, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorBetween(String value1, String value2) {
            addCriterion("INAUTHOR between", value1, value2, "inauthor");
            return (Criteria) this;
        }

        public Criteria andInauthorNotBetween(String value1, String value2) {
            addCriterion("INAUTHOR not between", value1, value2, "inauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorIsNull() {
            addCriterion("UPAUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andUpauthorIsNotNull() {
            addCriterion("UPAUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andUpauthorEqualTo(String value) {
            addCriterion("UPAUTHOR =", value, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorNotEqualTo(String value) {
            addCriterion("UPAUTHOR <>", value, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorGreaterThan(String value) {
            addCriterion("UPAUTHOR >", value, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorGreaterThanOrEqualTo(String value) {
            addCriterion("UPAUTHOR >=", value, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorLessThan(String value) {
            addCriterion("UPAUTHOR <", value, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorLessThanOrEqualTo(String value) {
            addCriterion("UPAUTHOR <=", value, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorLike(String value) {
            addCriterion("UPAUTHOR like", value, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorNotLike(String value) {
            addCriterion("UPAUTHOR not like", value, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorIn(List<String> values) {
            addCriterion("UPAUTHOR in", values, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorNotIn(List<String> values) {
            addCriterion("UPAUTHOR not in", values, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorBetween(String value1, String value2) {
            addCriterion("UPAUTHOR between", value1, value2, "upauthor");
            return (Criteria) this;
        }

        public Criteria andUpauthorNotBetween(String value1, String value2) {
            addCriterion("UPAUTHOR not between", value1, value2, "upauthor");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgIsNull() {
            addCriterion("INVOICE_IMG is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgIsNotNull() {
            addCriterion("INVOICE_IMG is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgEqualTo(String value) {
            addCriterion("INVOICE_IMG =", value, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgNotEqualTo(String value) {
            addCriterion("INVOICE_IMG <>", value, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgGreaterThan(String value) {
            addCriterion("INVOICE_IMG >", value, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgGreaterThanOrEqualTo(String value) {
            addCriterion("INVOICE_IMG >=", value, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgLessThan(String value) {
            addCriterion("INVOICE_IMG <", value, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgLessThanOrEqualTo(String value) {
            addCriterion("INVOICE_IMG <=", value, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgLike(String value) {
            addCriterion("INVOICE_IMG like", value, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgNotLike(String value) {
            addCriterion("INVOICE_IMG not like", value, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgIn(List<String> values) {
            addCriterion("INVOICE_IMG in", values, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgNotIn(List<String> values) {
            addCriterion("INVOICE_IMG not in", values, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgBetween(String value1, String value2) {
            addCriterion("INVOICE_IMG between", value1, value2, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andInvoiceImgNotBetween(String value1, String value2) {
            addCriterion("INVOICE_IMG not between", value1, value2, "invoiceImg");
            return (Criteria) this;
        }

        public Criteria andIsDelIsNull() {
            addCriterion("IS_DEL is null");
            return (Criteria) this;
        }

        public Criteria andIsDelIsNotNull() {
            addCriterion("IS_DEL is not null");
            return (Criteria) this;
        }

        public Criteria andIsDelEqualTo(Integer value) {
            addCriterion("IS_DEL =", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotEqualTo(Integer value) {
            addCriterion("IS_DEL <>", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelGreaterThan(Integer value) {
            addCriterion("IS_DEL >", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelGreaterThanOrEqualTo(Integer value) {
            addCriterion("IS_DEL >=", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLessThan(Integer value) {
            addCriterion("IS_DEL <", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLessThanOrEqualTo(Integer value) {
            addCriterion("IS_DEL <=", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelIn(List<Integer> values) {
            addCriterion("IS_DEL in", values, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotIn(List<Integer> values) {
            addCriterion("IS_DEL not in", values, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelBetween(Integer value1, Integer value2) {
            addCriterion("IS_DEL between", value1, value2, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotBetween(Integer value1, Integer value2) {
            addCriterion("IS_DEL not between", value1, value2, "isDel");
            return (Criteria) this;
        }

        public Criteria andPcontactIsNull() {
            addCriterion("PCONTACT is null");
            return (Criteria) this;
        }

        public Criteria andPcontactIsNotNull() {
            addCriterion("PCONTACT is not null");
            return (Criteria) this;
        }

        public Criteria andPcontactEqualTo(String value) {
            addCriterion("PCONTACT =", value, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactNotEqualTo(String value) {
            addCriterion("PCONTACT <>", value, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactGreaterThan(String value) {
            addCriterion("PCONTACT >", value, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactGreaterThanOrEqualTo(String value) {
            addCriterion("PCONTACT >=", value, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactLessThan(String value) {
            addCriterion("PCONTACT <", value, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactLessThanOrEqualTo(String value) {
            addCriterion("PCONTACT <=", value, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactLike(String value) {
            addCriterion("PCONTACT like", value, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactNotLike(String value) {
            addCriterion("PCONTACT not like", value, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactIn(List<String> values) {
            addCriterion("PCONTACT in", values, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactNotIn(List<String> values) {
            addCriterion("PCONTACT not in", values, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactBetween(String value1, String value2) {
            addCriterion("PCONTACT between", value1, value2, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPcontactNotBetween(String value1, String value2) {
            addCriterion("PCONTACT not between", value1, value2, "pcontact");
            return (Criteria) this;
        }

        public Criteria andPphoneIsNull() {
            addCriterion("PPHONE is null");
            return (Criteria) this;
        }

        public Criteria andPphoneIsNotNull() {
            addCriterion("PPHONE is not null");
            return (Criteria) this;
        }

        public Criteria andPphoneEqualTo(String value) {
            addCriterion("PPHONE =", value, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneNotEqualTo(String value) {
            addCriterion("PPHONE <>", value, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneGreaterThan(String value) {
            addCriterion("PPHONE >", value, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneGreaterThanOrEqualTo(String value) {
            addCriterion("PPHONE >=", value, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneLessThan(String value) {
            addCriterion("PPHONE <", value, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneLessThanOrEqualTo(String value) {
            addCriterion("PPHONE <=", value, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneLike(String value) {
            addCriterion("PPHONE like", value, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneNotLike(String value) {
            addCriterion("PPHONE not like", value, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneIn(List<String> values) {
            addCriterion("PPHONE in", values, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneNotIn(List<String> values) {
            addCriterion("PPHONE not in", values, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneBetween(String value1, String value2) {
            addCriterion("PPHONE between", value1, value2, "pphone");
            return (Criteria) this;
        }

        public Criteria andPphoneNotBetween(String value1, String value2) {
            addCriterion("PPHONE not between", value1, value2, "pphone");
            return (Criteria) this;
        }

        public Criteria andBillpathIsNull() {
            addCriterion("BILLPATH is null");
            return (Criteria) this;
        }

        public Criteria andBillpathIsNotNull() {
            addCriterion("BILLPATH is not null");
            return (Criteria) this;
        }

        public Criteria andBillpathEqualTo(String value) {
            addCriterion("BILLPATH =", value, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathNotEqualTo(String value) {
            addCriterion("BILLPATH <>", value, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathGreaterThan(String value) {
            addCriterion("BILLPATH >", value, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathGreaterThanOrEqualTo(String value) {
            addCriterion("BILLPATH >=", value, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathLessThan(String value) {
            addCriterion("BILLPATH <", value, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathLessThanOrEqualTo(String value) {
            addCriterion("BILLPATH <=", value, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathLike(String value) {
            addCriterion("BILLPATH like", value, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathNotLike(String value) {
            addCriterion("BILLPATH not like", value, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathIn(List<String> values) {
            addCriterion("BILLPATH in", values, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathNotIn(List<String> values) {
            addCriterion("BILLPATH not in", values, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathBetween(String value1, String value2) {
            addCriterion("BILLPATH between", value1, value2, "billpath");
            return (Criteria) this;
        }

        public Criteria andBillpathNotBetween(String value1, String value2) {
            addCriterion("BILLPATH not between", value1, value2, "billpath");
            return (Criteria) this;
        }

        public Criteria andCJPersonIsNull() {
            addCriterion("C_J_PERSON is null");
            return (Criteria) this;
        }

        public Criteria andCJPersonIsNotNull() {
            addCriterion("C_J_PERSON is not null");
            return (Criteria) this;
        }

        public Criteria andCJPersonEqualTo(String value) {
            addCriterion("C_J_PERSON =", value, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonNotEqualTo(String value) {
            addCriterion("C_J_PERSON <>", value, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonGreaterThan(String value) {
            addCriterion("C_J_PERSON >", value, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonGreaterThanOrEqualTo(String value) {
            addCriterion("C_J_PERSON >=", value, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonLessThan(String value) {
            addCriterion("C_J_PERSON <", value, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonLessThanOrEqualTo(String value) {
            addCriterion("C_J_PERSON <=", value, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonLike(String value) {
            addCriterion("C_J_PERSON like", value, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonNotLike(String value) {
            addCriterion("C_J_PERSON not like", value, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonIn(List<String> values) {
            addCriterion("C_J_PERSON in", values, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonNotIn(List<String> values) {
            addCriterion("C_J_PERSON not in", values, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonBetween(String value1, String value2) {
            addCriterion("C_J_PERSON between", value1, value2, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPersonNotBetween(String value1, String value2) {
            addCriterion("C_J_PERSON not between", value1, value2, "cJPerson");
            return (Criteria) this;
        }

        public Criteria andCJPhoneIsNull() {
            addCriterion("C_J_PHONE is null");
            return (Criteria) this;
        }

        public Criteria andCJPhoneIsNotNull() {
            addCriterion("C_J_PHONE is not null");
            return (Criteria) this;
        }

        public Criteria andCJPhoneEqualTo(String value) {
            addCriterion("C_J_PHONE =", value, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneNotEqualTo(String value) {
            addCriterion("C_J_PHONE <>", value, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneGreaterThan(String value) {
            addCriterion("C_J_PHONE >", value, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("C_J_PHONE >=", value, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneLessThan(String value) {
            addCriterion("C_J_PHONE <", value, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneLessThanOrEqualTo(String value) {
            addCriterion("C_J_PHONE <=", value, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneLike(String value) {
            addCriterion("C_J_PHONE like", value, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneNotLike(String value) {
            addCriterion("C_J_PHONE not like", value, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneIn(List<String> values) {
            addCriterion("C_J_PHONE in", values, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneNotIn(List<String> values) {
            addCriterion("C_J_PHONE not in", values, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneBetween(String value1, String value2) {
            addCriterion("C_J_PHONE between", value1, value2, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andCJPhoneNotBetween(String value1, String value2) {
            addCriterion("C_J_PHONE not between", value1, value2, "cJPhone");
            return (Criteria) this;
        }

        public Criteria andAddrIdIsNull() {
            addCriterion("ADDR_ID is null");
            return (Criteria) this;
        }

        public Criteria andAddrIdIsNotNull() {
            addCriterion("ADDR_ID is not null");
            return (Criteria) this;
        }

        public Criteria andAddrIdEqualTo(String value) {
            addCriterion("ADDR_ID =", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdNotEqualTo(String value) {
            addCriterion("ADDR_ID <>", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdGreaterThan(String value) {
            addCriterion("ADDR_ID >", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdGreaterThanOrEqualTo(String value) {
            addCriterion("ADDR_ID >=", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdLessThan(String value) {
            addCriterion("ADDR_ID <", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdLessThanOrEqualTo(String value) {
            addCriterion("ADDR_ID <=", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdLike(String value) {
            addCriterion("ADDR_ID like", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdNotLike(String value) {
            addCriterion("ADDR_ID not like", value, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdIn(List<String> values) {
            addCriterion("ADDR_ID in", values, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdNotIn(List<String> values) {
            addCriterion("ADDR_ID not in", values, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdBetween(String value1, String value2) {
            addCriterion("ADDR_ID between", value1, value2, "addrId");
            return (Criteria) this;
        }

        public Criteria andAddrIdNotBetween(String value1, String value2) {
            addCriterion("ADDR_ID not between", value1, value2, "addrId");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table CONFIG_CUSTOMER
     *
     * @mbg.generated do_not_delete_during_merge Wed Jul 12 08:41:20 CST 2017
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}